[dbo].[BAEEventGetRegistrantAnswer]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetRegistrantAnswer

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@RegistrantID	varchar(16)	16
@EventCode	varchar(16)	16
@questionID	int	4

SQL Script

create procedure [dbo].[BAEEventGetRegistrantAnswer] @RegistrantID VARCHAR(16),
     @EventCode VARCHAR(16),
     @questionID int as
SELECT  *
    FROM EventRegistrationAnswer AS a
    WHERE a.QuestionID = @questionID AND
        a.RegistrantID = @RegistrantID AND
        a.EventCode = @EventCode

GO

Uses

[dbo].[EventRegistrationAnswer]
dbo